IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[UpdateCocina]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[UpdateCocina]
GO

CREATE PROCEDURE [dbo].[UpdateCocina]
(
	@cocinaID int,
	@fecha datetime,
	@personalID smallint,
	@loteID int,
	@almacenID smallint,
	@cantidad float(53),
	@estado char(1)
)
AS
BEGIN
	SET NOCOUNT ON

	UPDATE [Cocina]
	SET [fecha] = @fecha, 
		[personalID] = @personalID, 
		[loteID] = @loteID, 
		[almacenID] = @almacenID, 
		[cantidad] = @cantidad,
		[estado] = @estado
	WHERE [cocinaID] = @cocinaID

	SET NOCOUNT OFF
END

GO
